BEGIN TRAN

USE [Survey]  /* change to your project DB */


CREATE TABLE [Question] (
  [QuestionId] int NOT NULL  IDENTITY (2,1)
, [Title] nvarchar(250) NOT NULL
, [Description] nvarchar(2000) NOT NULL
, [IsApproved] bit NOT NULL
, [ValidUntil] datetime NOT NULL
);
GO

CREATE TABLE [Answer] (
  [Title] nvarchar(250) NOT NULL
, [Description] nvarchar(2000) NOT NULL
, [Count] int NOT NULL
, [QuestionId] int NOT NULL
, [Index] int NOT NULL
);
GO

--ROLLBACK TRAN
COMMIT TRAN